{
  "properties" : { },
  "id" : "71d6999cfb6b4bbb8f4d8c81a292bdb7",
  "script" : null,
  "groupId" : "9cdf911ce9e04b62976717998469c655",
  "name" : "获取topo端口绑定列表",
  "createTime" : 1727071145792,
  "updateTime" : 1727060550381,
  "lock" : "1",
  "createBy" : "ndmp",
  "updateBy" : "ndmp",
  "path" : "portList",
  "method" : "GET",
  "parameters" : [ {
    "name" : "deviceId",
    "value" : "D5248109091915608175",
    "description" : "",
    "required" : false,
    "dataType" : "String",
    "type" : "",
    "defaultValue" : "",
    "validateType" : "",
    "error" : "",
    "expression" : "",
    "children" : [ ]
  } ],
  "options" : [ ],
  "requestBody" : "",
  "headers" : [ ],
  "paths" : [ ],
  "responseBody" : "{\n    \"status\": 200,\n    \"message\": \"success\",\n    \"data\": [\n        {\n            \"id\": \"1\",\n            \"deviceId\": \"D5248109091915608175\",\n            \"ifType\": \"1\",\n            \"iftypecn\": \"Console或Cellular接口\",\n            \"ifIndex\": \"3\",\n            \"ifDescr\": \"Cellular\",\n            \"ifPhysAddress\": \"地址\",\n            \"ifHighSpeed\": \"\",\n            \"ifAlias\": \"测试\",\n            \"ifOperStatus\": \"1\",\n            \"ifAdminStatus\": \"1\",\n            \"time\": \"2024-09-24 09:06:02\"\n        }\n    ]\n}",
  "description" : "",
  "requestBodyDefinition" : {
    "name" : "",
    "value" : { },
    "description" : "",
    "required" : false,
    "dataType" : "String",
    "type" : "",
    "defaultValue" : "",
    "validateType" : "",
    "error" : "",
    "expression" : "",
    "children" : [ ]
  },
  "responseBodyDefinition" : {
    "name" : "",
    "value" : { },
    "description" : "",
    "required" : false,
    "dataType" : "String",
    "type" : "",
    "defaultValue" : "",
    "validateType" : "",
    "error" : "",
    "expression" : "",
    "children" : [ ]
  }
}
================================
import java.util.stream.Collectors

sql = """
    select id, device_id, if_type,
           (select dict_value from blade_dict 
            where code='ifType' and is_sealed='0' and is_deleted='0' and dict_key=if_type) if_type_cn,
           if_index, if_descr, if_phys_address, if_high_speed, if_alias, if_oper_status, if_admin_status, time
    from ndmp_device_net_if where device_id = #{deviceId} order by if_index
"""

deviceNetif = db.select(sql)

List list = deviceNetif.stream()
    .filter(s -> !("1".equals(s.ifType) && !(s.ifDescr.contains("Cellular") || s.ifDescr.contains("Console"))))
    .collect(Collectors.toList());

return list